[Job 19489] Data Architect (Tech Lead) - Snowflake & dbt Expert, Brazil (copy)

As a Data Architect (Tech Lead) at CI&T, your main responsibilities include leading the design and implementation of scalable data solutions using Snowflake and dbt, ensuring data integrity, usability, and security, and mentoring team members on best practices. You will also document data architectures, integrate data quality measures, and manage CI/CD pipelines for ETL processes.

To qualify for the Data Architect (Tech Lead) position at CI&T, you should have a Bachelor’s degree in Computer Science, Information Technology, or a related field. Solid experience with Snowflake and dbt, advanced SQL knowledge, and familiarity with Agile methodologies are essential. Additionally, strong problem-solving skills and excellent communication abilities in English are important.

At CI&T, the working environment for a Data Architect is dynamic and collaborative, driven by a diverse team focused on innovation and transformation. Employees are encouraged to share ideas and collaborate across different backgrounds, ensuring a rich exchange of perspectives and experiences to achieve impactful results.

CI&T is committed to the professional growth of Data Architects through mentorship programs, dedicated career advisors, and ongoing learning opportunities. This support allows team members to develop their skills further while contributing to exciting and challenging technical projects.

CI&T offers a great package of perks and benefits to its Data Architects, including a competitive salary, generous vacation days, unlimited sick time, 100% paid health and dental benefits from day one, retirement matching, paid parental leave, and annual profit-sharing. These benefits reflect our commitment to employee well-being and work-life balance.

When asked about your experience with Snowflake and dbt, be sure to highlight specific projects where you successfully utilized these tools. Discuss the design and implementation of data architectures and any challenges you faced, focusing on your problem-solving approach and outcomes. Concrete examples will provide insight into your skills.

To ensure data integrity and security, outline your processes for validating data, implementing access controls, and conducting regular audits. Discuss any frameworks or standards you follow and emphasize your proactive approach to addressing potential risks in data management.

When discussing methodologies, describe your experience with Agile and Scrum and how they enhance collaboration and efficiency during projects. Provide an example of how employing these methodologies resulted in a successful outcome, underscoring the importance of adaptability in project management.

Explain your mentorship style and how you promote a culture of learning within your team. Share examples of how you've helped team members overcome challenges, provided feedback on their work, or encouraged them to explore new technologies or methodologies.

Discuss the specific tools you utilize for CI/CD in ETL processes, such as version control systems like Git and deployment pipelines. Explain your approach to automating deployments, testing, and monitoring, and how these practices enhance the efficiency of data pipelines.

Your answer should include the strategies you implement to assess and maintain data quality, including validation checks, data profiling, and data cleansing techniques. Provide examples of issues you've resolved through effective data quality practices and how you ensure these standards are upheld consistently.

Talk about your commitment to continuous learning by attending workshops, following industry news, participating in online courses, and engaging with communities. Share how you've applied new knowledge to your work to drive innovation and improvement in data architectures.

When faced with this question, recount a specific project where you encountered significant challenges. Focus on your role, the technical solutions you implemented, and the successes achieved through teamwork and strategic planning to demonstrate your capabilities as a Data Architect.

Your response should reflect your ability to analyze project requirements and deadlines, using prioritization frameworks or tools. Share techniques you use to manage your time effectively while ensuring that team objectives are aligned.

Discuss your perspective on the key qualities that make a successful Data Architect, such as strong analytical skills, adaptability, effective communication, and a collaborative mindset. Provide examples of how these qualities have positively impacted your previous roles.